<ul class="ui-listview ui-listview-inset ui-corner-all ui-shadow" data-role="listview" data-filter="true" data-filter-placeholder="Auftraggeber suchen..." data-filter-theme="c">
    <li class="ui-li ui-li-static ui-body-c ui-corner-top" data-role="list-divider">Auftraggeber</li>
    <?php

        $sql = "SELECT * FROM client c LEFT JOIN address a ON (c.address_id = a.address_id)";
        $result = mysql_query($sql);

        if (mysql_num_rows($result) > 0) {
            while ($data = mysql_fetch_array($result)) {
    ?>
                <li>
                    <a href="edit.php?client_id=<?php echo $data['client_id']; ?>&address_id=<?php echo $data['address_id']; ?>&street=<?php echo $data['street']; ?>&zip=<?php echo $data['zip']; ?>&city=<?php echo $data['city']; ?>&name=<?php echo $data['name']; ?>&form=cl">
                        <?php echo $data['name']; ?>
                    </a>
                </li>
    <?php
            }
        }
    ?>
</ul>
